/*
 Navicat Premium Data Transfer

 Source Server         : 海南奥和
 Source Server Type    : SQL Server
 Source Server Version : 10501600
 Source Host           : hnah2014.xicp.net:1688
 Source Catalog        : cs
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 10501600
 File Encoding         : 65001

 Date: 01/01/2024 21:40:53
*/


-- ----------------------------
-- Table structure for zxy_BhgYSJLRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_BhgYSJLRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_BhgYSJLRes]
GO

CREATE TABLE [dbo].[zxy_BhgYSJLRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_OWNER_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_OWNER_SYSTEM_LINE_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ghdw] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [yanshoua] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_INSPECT_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_INSPECT_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_VENDOR_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAH_HINT_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_LOGISTICS_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tyming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billdtlid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [yanshoujieguo] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [il_material_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_CHECK_RESULT] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [qingkuangshuoming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RH_RECV_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Ih_owner_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_DATE0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_DATE1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RL_RECV_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [flag] int DEFAULT ((0)) NOT NULL,
  [erpBillType] varchar(30) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[zxy_BhgYSJLRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_dsckfhRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_dsckfhRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_dsckfhRes]
GO

CREATE TABLE [dbo].[zxy_dsckfhRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [flag] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKH_OWNER_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_OWNER_SYSTEM_LINE_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [zjian] varchar(55) COLLATE Chinese_PRC_CI_AS  NULL,
  [Zjian2] varchar(55) COLLATE Chinese_PRC_CI_AS  NULL,
  [ljian] varchar(55) COLLATE Chinese_PRC_CI_AS  NULL,
  [ljian2] varchar(55) COLLATE Chinese_PRC_CI_AS  NULL,
  [jhr] varchar(55) COLLATE Chinese_PRC_CI_AS  NULL,
  [BILLID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billdtlid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAH_HINT_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MATERIAL_STATUS] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKH_LOGISTICS_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKH_PICK_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_LOT_DATE0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_LOT_DATE1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_LOT_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_MATERIAL_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_PICK_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [gouhuodanwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [pkh_owner_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tyming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [qfflag] int DEFAULT ((0)) NOT NULL,
  [erpBillType] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[zxy_dsckfhRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_dsshjlRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_dsshjlRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_dsshjlRes]
GO

CREATE TABLE [dbo].[zxy_dsshjlRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [DAODAWENDU] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAH_HINT_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RH_LOGISTICS_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RH_OWNER_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RH_RECV_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RH_VENDOR_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RL_LOT_DATE0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RL_LOT_DATE1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RL_LOT_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RL_MATERIAL_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RL_RECV_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [YUNSHUYAOQIU] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billdtlid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [czy] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ghdw] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [tyming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [yunshufangshi] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [yunshushijian] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [daodashijian] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [fayundidian] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [wenkongfangshi] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [WENDUJILU] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [yunshudanwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RH_OWNER_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RL_OWNER_SYSTEM_LINE_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [flag] int DEFAULT ((0)) NOT NULL,
  [erpBillType] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[zxy_dsshjlRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_dsStcokBHGRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_dsStcokBHGRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_dsStcokBHGRes]
GO

CREATE TABLE [dbo].[zxy_dsStcokBHGRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [RUKUDATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [mah_hint_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [HUOZHU] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [SHENGCAN] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [LAIYUAN] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [YOUXIAO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PIHAO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tongyong] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RUKUSHULIANG] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [flag] int DEFAULT ((0)) NOT NULL
)
GO

ALTER TABLE [dbo].[zxy_dsStcokBHGRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_dsstockRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_dsstockRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_dsstockRes]
GO

CREATE TABLE [dbo].[zxy_dsstockRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [MAH_HINT_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_BIG_CASE_RATIO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [cangku] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [chuwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [qt_lot_date0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [qt_lot_date1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [qt_lot_string0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [qt_material_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [qt_material_status] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [qt_onhand_qty] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [qt_owner_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [qt_recv_date] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tyming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [flag] int DEFAULT ((0)) NOT NULL
)
GO

ALTER TABLE [dbo].[zxy_dsstockRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_dsstockYHJLRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_dsstockYHJLRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_dsstockYHJLRes]
GO

CREATE TABLE [dbo].[zxy_dsstockYHJLRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [mah_hint_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MNH_OWNER_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MNH_MAINTAIN_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MENDER] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [mnh_app_use_remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MNH_DISPOSE_ATTITUDE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tongyong] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MNH_VALID_UNTIL_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [BILLDTLID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [mnl_qty] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MNH_PRODUCT_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [flag] int DEFAULT ((0)) NOT NULL
)
GO

ALTER TABLE [dbo].[zxy_dsstockYHJLRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_dswtysjlRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_dswtysjlRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_dswtysjlRes]
GO

CREATE TABLE [dbo].[zxy_dswtysjlRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [loh_owner_no] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [LOL_OWNER_SYSTEM_LINE_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CLH_CONSIGNER_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CLH_UNLOAD_ADDRESS] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CLH_UNLOAD_UNIT_NAME] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CLL_CONSIGN_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CLL_MATERIAL_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [DRIVER] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [LOH_LOGISTICS_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAH_HINT_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [fahuoshijian] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [signdate1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tphao] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tyming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [wo] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [yunshushixian] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [fcwd] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [zongjianshu] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [flag] int DEFAULT ((0)) NOT NULL
)
GO

ALTER TABLE [dbo].[zxy_dswtysjlRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_dsXTysjlRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_dsXTysjlRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_dsXTysjlRes]
GO

CREATE TABLE [dbo].[zxy_dsXTysjlRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_OWNER_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ghdw] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_REMARK] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [yanshoua] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_INSPECT_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_INSPECT_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_VENDOR_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAH_HINT_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_OWNER_SYSTEM_LINE_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_LOGISTICS_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tyming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [billdtlid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [il_material_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RH_RECV_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Ih_owner_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_DATE0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [yaopinzt] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_DATE1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [flag] int DEFAULT ((0)) NOT NULL,
  [erpBillType] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[zxy_dsXTysjlRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_dsysbhgRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_dsysbhgRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_dsysbhgRes]
GO

CREATE TABLE [dbo].[zxy_dsysbhgRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_OWNER_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_OWNER_SYSTEM_LINE_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ghdw] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [yanshoua] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_INSPECT_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_INSPECT_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_VENDOR_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAH_HINT_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_LOGISTICS_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tyming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [yanshoujieguo] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [il_material_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_CHECK_RESULT] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [qingkuangshuoming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RH_RECV_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Ih_owner_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_DATE0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_DATE1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RL_RECV_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [flag] int DEFAULT ((0)) NOT NULL,
  [erpBillType] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[zxy_dsysbhgRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_dsysjlRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_dsysjlRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_dsysjlRes]
GO

CREATE TABLE [dbo].[zxy_dsysjlRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [IH_INSPECT_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_LOGISTICS_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_VENDOR_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_INSPECT_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_DATE0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_DATE1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_LOT_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Ih_owner_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAH_HINT_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RH_RECV_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [RL_RECV_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billdtlid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ghdw] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [il_material_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [tyming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [yanshoua] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [yaopinzt] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [flag] int DEFAULT ((0)) NOT NULL,
  [IH_OWNER_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IL_OWNER_SYSTEM_LINE_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [erpBillType] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[zxy_dsysjlRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_JTOutStockJL
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_JTOutStockJL]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_JTOutStockJL]
GO

CREATE TABLE [dbo].[zxy_JTOutStockJL] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [PKH_OWNER_ID] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [mah_hint_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_OWNER_SYSTEM_LINE_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tuihuoyuanyin] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKH_OWNER_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_LOT_DATE0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_LOT_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_LOT_DATE1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tongyong] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKH_PICK_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tuidanwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [PKL_PICK_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [flag] int DEFAULT ((0)) NULL,
  [erpBillType] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[zxy_JTOutStockJL] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_qfbillId
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_qfbillId]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_qfbillId]
GO

CREATE TABLE [dbo].[zxy_qfbillId] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [billId] int  NOT NULL,
  [billType] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [createDate] datetime DEFAULT (getdate()) NULL
)
GO

ALTER TABLE [dbo].[zxy_qfbillId] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_shjushouRes
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_shjushouRes]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_shjushouRes]
GO

CREATE TABLE [dbo].[zxy_shjushouRes] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [MAT_MANUFACTURER_Name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_OWNER_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [mah_hint_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [danwei] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CST_RL_REJECT_REASON] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [tongming] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [jixing] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [IH_INSPECT_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [cst_rh_owner_id] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CST_RH_REJECT_DATE] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [billdtlid] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CST_RL_LOT_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [MAT_CUSTOMER_STRING0] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CST_RH_VENDOR_name] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [nodeid] int  NULL,
  [CST_RL_LOT_DATE1] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CST_RL_REJECT_QTY] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CST_RL_MAT_SPEC] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [flag] int DEFAULT ((0)) NOT NULL,
  [IL_OWNER_SYSTEM_LINE_NO] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [erpBillType] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[zxy_shjushouRes] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Table structure for zxy_UpLoadBill_ds
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[zxy_UpLoadBill_ds]') AND type IN ('U'))
	DROP TABLE [dbo].[zxy_UpLoadBill_ds]
GO

CREATE TABLE [dbo].[zxy_UpLoadBill_ds] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [billCode] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [ord] int  NULL,
  [billtype] int  NOT NULL,
  [create_date] datetime DEFAULT (getdate()) NULL,
  [uploadFlags] int DEFAULT ((0)) NOT NULL,
  [uploadDate] datetime  NULL,
  [deleted] int DEFAULT ((0)) NOT NULL,
  [deleted_date] datetime  NULL,
  [ysjl_flags] int DEFAULT ((0)) NOT NULL,
  [getysjl_date] datetime  NULL,
  [ckfh_flags] int DEFAULT ((0)) NOT NULL,
  [getckfh_date] datetime  NULL,
  [jk_result] varchar(8000) COLLATE Chinese_PRC_CI_AS  NULL,
  [jk_ids] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [back_message] varchar(8000) COLLATE Chinese_PRC_CI_AS  NULL,
  [comment] varchar(8000) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[zxy_UpLoadBill_ds] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'行号',
'SCHEMA', N'dbo',
'TABLE', N'zxy_UpLoadBill_ds',
'COLUMN', N'ord'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单据类型
11：销售单
34：采购单
6 ：采购退货单
45：销售退货单',
'SCHEMA', N'dbo',
'TABLE', N'zxy_UpLoadBill_ds',
'COLUMN', N'billtype'
GO

EXEC sp_addextendedproperty
'MS_Description', N'九州通id集合,主要是区分采购入库单数据是否拉取完成中间用，分割',
'SCHEMA', N'dbo',
'TABLE', N'zxy_UpLoadBill_ds',
'COLUMN', N'jk_ids'
GO


-- ----------------------------
-- Auto increment value for zxy_BhgYSJLRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_BhgYSJLRes]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table zxy_BhgYSJLRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_BhgYSJLRes] ADD CONSTRAINT [PK_zxy_BhgYSJLRes] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_dsckfhRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_dsckfhRes]', RESEED, 6)
GO


-- ----------------------------
-- Primary Key structure for table zxy_dsckfhRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_dsckfhRes] ADD CONSTRAINT [PK_zxy_dsckfhRes] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_dsshjlRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_dsshjlRes]', RESEED, 7)
GO


-- ----------------------------
-- Primary Key structure for table zxy_dsshjlRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_dsshjlRes] ADD CONSTRAINT [PK_zxy_dsshjlRes] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_dsStcokBHGRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_dsStcokBHGRes]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table zxy_dsStcokBHGRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_dsStcokBHGRes] ADD CONSTRAINT [PK_zxy_dsStcokBHG] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_dsstockRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_dsstockRes]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table zxy_dsstockRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_dsstockRes] ADD CONSTRAINT [PK_zxy_dsstockRes] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_dsstockYHJLRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_dsstockYHJLRes]', RESEED, 42)
GO


-- ----------------------------
-- Primary Key structure for table zxy_dsstockYHJLRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_dsstockYHJLRes] ADD CONSTRAINT [PK_zxy_dsstockYHJLRes] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_dswtysjlRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_dswtysjlRes]', RESEED, 5)
GO


-- ----------------------------
-- Primary Key structure for table zxy_dswtysjlRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_dswtysjlRes] ADD CONSTRAINT [PK_zxy_dswtysjlRes] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_dsXTysjlRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_dsXTysjlRes]', RESEED, 6)
GO


-- ----------------------------
-- Primary Key structure for table zxy_dsXTysjlRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_dsXTysjlRes] ADD CONSTRAINT [PK_zxy_dsXTysjlRes] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_dsysbhgRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_dsysbhgRes]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table zxy_dsysbhgRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_dsysbhgRes] ADD CONSTRAINT [PK_zxy_ysbhgRes] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_dsysjlRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_dsysjlRes]', RESEED, 34)
GO


-- ----------------------------
-- Primary Key structure for table zxy_dsysjlRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_dsysjlRes] ADD CONSTRAINT [PK_zxy_dsysjlRes] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_JTOutStockJL
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_JTOutStockJL]', RESEED, 38)
GO


-- ----------------------------
-- Primary Key structure for table zxy_JTOutStockJL
-- ----------------------------
ALTER TABLE [dbo].[zxy_JTOutStockJL] ADD CONSTRAINT [PK_zxy_JTOutStockJL] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_qfbillId
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_qfbillId]', RESEED, 2)
GO


-- ----------------------------
-- Primary Key structure for table zxy_qfbillId
-- ----------------------------
ALTER TABLE [dbo].[zxy_qfbillId] ADD CONSTRAINT [PK_zxy_qfbillId] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, FILLFACTOR = 100, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_shjushouRes
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_shjushouRes]', RESEED, 117)
GO


-- ----------------------------
-- Primary Key structure for table zxy_shjushouRes
-- ----------------------------
ALTER TABLE [dbo].[zxy_shjushouRes] ADD CONSTRAINT [PK_zxy_shjushouRes] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for zxy_UpLoadBill_ds
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[zxy_UpLoadBill_ds]', RESEED, 13)
GO


-- ----------------------------
-- Primary Key structure for table zxy_UpLoadBill_ds
-- ----------------------------
ALTER TABLE [dbo].[zxy_UpLoadBill_ds] ADD CONSTRAINT [PK__zxy_UpLo__3213E83F107E6C10] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, FILLFACTOR = 100, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

